Trulia is looking for a data warehouse engineer to help build and maintain our warehouse of Web events and user data. The ideal candidate has a deep understanding of the technical and functional aspects of database, data warehouse and report design.
Responsibilities
• Actively participate in the technical design, implementation and maintenance of data modeling, ETL and reporting tasks. • Perform all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting and analytics. • Quickly assess the impact of production system changes to the existing warehouse, and implement changes to the warehouse ETL and reporting code to ensure consistent and accurate reporting.
Requirements
• Excellent MySQL skills. • Min 3 years of experience working in a data warehouse environment. • Experience designing and developing custom ETL systems for complex, multi-source data warehouse applications. • Strong programming skills and extensive knowledge of Unix/Linux and scripting skills (Perl, shell, Python, XML). • Excellent interpersonal and communication skills. • Excellent attention to detail. • Knowledge of data partitioning at the software and hardware level. • Good understanding of MySQL performance tuning, indexes, optimization, query plan analysis, and locks. • M.S or B.S in computer science, or equivalent.
Nice to have: • Experience with Hadoop, map/reduce, and Pig • PostgreSQL
Fair Housing and Equal Opportunity logo Fair Housing and Equal Opportunity